package com.cxl.springboot.dao;

import org.apache.ibatis.annotations.Select;

public interface UserCount {
    @Select("select count(*) from `sys_user` where (username LIKE CONCAT('%', #{key}, '%') OR" +
            "                nickname LIKE CONCAT('%', #{key}, '%') OR" +
            "                email LIKE CONCAT('%', #{key}, '%') OR" +
            "                phone LIKE CONCAT('%', #{key}, '%') OR" +
            "                address LIKE CONCAT('%', #{key}, '%'))")
    int userCount(String key);
}
